Tabela Personnel

Definicja tabeli Personnel

Name

Personnel

Code

Personnel

Comment

PL: Dane personelu – uzupelnienie danych osobowych
EN: Personnel person data – person table complement


Lista kolumn tabeli Personnel

Name

Code

PersonID

PersonID

PersonnelTypeMHID

PersonnelTypeMHID

GradeGroupID

GradeGroupID

Per_PersonID2

Per_PersonID2

Per_PersonID3

Per_PersonID3

Code

Code

InterfaceCd

InterfaceCd

LicenceNo

LicenceNo

SickLeaveLicenceNoID

SickLeaveLicenceNoID

Active

Active

StartDT

StartDT

StopDT

StopDT

Comments

Comments

OtherWorkPlace

OtherWorkPlace

LicenceNo2

LicenceNo2

isExternal

isExternal

IsMedical

IsMedical


Kolumna PersonID tabeli Personnel

Definicja kolumny PersonID tabeli Personnel

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelTypeMHID tabeli Personnel

Definicja kolumny PersonnelTypeMHID tabeli Personnel

Name

PersonnelTypeMHID

Code

PersonnelTypeMHID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GradeGroupID tabeli Personnel

Definicja kolumny GradeGroupID tabeli Personnel

Name

GradeGroupID

Code

GradeGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_PersonID2 tabeli Personnel

Definicja kolumny Per_PersonID2 tabeli Personnel

Name

Per_PersonID2

Code

Per_PersonID2

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_PersonID3 tabeli Personnel

Definicja kolumny Per_PersonID3 tabeli Personnel

Name

Per_PersonID3

Code

Per_PersonID3

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli Personnel

Definicja kolumny Code tabeli Personnel

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna InterfaceCd tabeli Personnel

Definicja kolumny InterfaceCd tabeli Personnel

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna LicenceNo tabeli Personnel

Definicja kolumny LicenceNo tabeli Personnel

Name

LicenceNo

Code

LicenceNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna SickLeaveLicenceNoID tabeli Personnel

Definicja kolumny SickLeaveLicenceNoID tabeli Personnel

Name

SickLeaveLicenceNoID

Code

SickLeaveLicenceNoID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna Active tabeli Personnel

Definicja kolumny Active tabeli Personnel

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Personnel

Definicja kolumny StartDT tabeli Personnel

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Personnel

Definicja kolumny StopDT tabeli Personnel

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli Personnel

Definicja kolumny Comments tabeli Personnel

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna OtherWorkPlace tabeli Personnel

Definicja kolumny OtherWorkPlace tabeli Personnel

Name

OtherWorkPlace

Code

OtherWorkPlace

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna LicenceNo2 tabeli Personnel

Definicja kolumny LicenceNo2 tabeli Personnel

Name

LicenceNo2

Code

LicenceNo2

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Drugi numer prawa wykonywania zawodu lekarza.


Kolumna isExternal tabeli Personnel

Definicja kolumny isExternal tabeli Personnel

Name

isExternal

Code

isExternal

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Personel nie nalezy do kadry szpitalnej, jest personelem zewnetrznym, jednak pelni podobne funkcje jak personel bedacy czescia kadry szpitalnej, ale nie powinien byc wykazywany w sprawozdaniach do NFZ.


Kolumna IsMedical tabeli Personnel

Definicja kolumny IsMedical tabeli Personnel

Name

IsMedical

Code

IsMedical

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Informacja, czy pracownik nalezy do grupy medycznej.


Lista kluczy tabeli Personnel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Personnel

Definicja klucza Identifier_1 tabeli Personnel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment